CREATE OR REPLACE PACKAGE TEST_LOGGER
As
    procedure LOGGER_PROC(v1 number,v2 number);
END TEST_LOGGER;
/
CREATE OR REPLACE PACKAGE BODY TEST_LOGGER
As
 gc_scope_prefix constant varchar2(31) := lower($$plsql_unit) || '.';

 procedure LOGGER_PROC(v1 number,v2 number)
 Is
  l_scope logger_logs.scope%type := gc_scope_prefix || 'LOGGER_PROC';
  l_params logger.tab_param;
  v3 number;
  begin
    logger.append_param(l_params, 'v1', v1);
    logger.append_param(l_params, 'v2', v2);
    logger.log('START', l_scope, null, l_params);

    v3:=v1/v2;

    logger.log('END', l_scope);
  exception When Others Then
    rollback;
    logger.log_error(Sqlerrm, l_scope, null, l_params);
    --raise;
 end LOGGER_PROC;

END TEST_LOGGER;
/
